Columns

Grants

Dependencies

Details

Triggers

Errors


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS INSERTABLE UPDATABLE DELETABLE
SID NUMBER Yes null 1 null NO NO NO
OBJ VARCHAR2(20) Yes null 2 null NO NO NO
ID VARCHAR2(100) Yes null 3 null NO NO NO
TITLE VARCHAR2(300) Yes null 4 null NO NO NO
ACTIVITY_DATE DATE Yes null 5 null NO NO NO
ACTIVITY_DATE_FY NUMBER Yes null 6 null NO NO NO
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_CUBE_ALL_ACTIVITIES VIEW QART V_ALL_ACTIVITIES VIEW



References


OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE
QART V_ALL_ACTIVITIES VIEW QART MV_A_ADVANCEMENT TABLE
QART V_ALL_ACTIVITIES VIEW QART MV_A_COMP_INTRUSION TABLE
QART V_ALL_ACTIVITIES VIEW QART MV_A_BRIEFING TABLE
QART V_ALL_ACTIVITIES VIEW QART MV_A_COORDINATION TABLE
QART V_ALL_ACTIVITIES VIEW QART MV_A_DATABASE_CHECK TABLE
QART V_ALL_ACTIVITIES VIEW QART MV_A_DEVELOPMENT TABLE
QART V_ALL_ACTIVITIES VIEW QART MV_A_DIGITAL TABLE
QART V_ALL_ACTIVITIES VIEW QART MV_A_DOCUMENT_REVIEW TABLE
QART V_ALL_ACTIVITIES VIEW QART MV_A_EXCEPTION TABLE
QART V_ALL_ACTIVITIES VIEW QART MV_A_INTERVIEW TABLE
QART V_ALL_ACTIVITIES VIEW QART MV_A_LIAISON TABLE
QART V_ALL_ACTIVITIES VIEW QART MV_A_PSYCH TABLE
QART V_ALL_ACTIVITIES VIEW QART MV_A_RECORDS_CHECK TABLE
NAME VALUE
CREATED 06-APR-23
LAST_DDL_TIME 10-OCT-24
OWNER QART
VIEW_NAME V_ALL_ACTIVITIES
TEXT_LENGTH 1962
TEXT SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_RECORDS_CHECK    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_COORDINATION    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_PSYCH    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_DOCUMENT_REVIEW    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_ADVANCEMENT    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_BRIEFING    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_COMP_INTRUSION    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_DIGITAL    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_INTERVIEW    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_DEVELOPMENT    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_EXCEPTION    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_LIAISON    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           REVIEW_DATE,           ACTIVITY_DATE_FY      FROM MV_A_DATABASE_CHECK
TEXT_VC SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_RECORDS_CHECK    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_COORDINATION    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_PSYCH    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_DOCUMENT_REVIEW    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_ADVANCEMENT    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_BRIEFING    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_COMP_INTRUSION    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_DIGITAL    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_INTERVIEW    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_DEVELOPMENT    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_EXCEPTION    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           ACTIVITY_DATE,           ACTIVITY_DATE_FY      FROM MV_A_LIAISON    UNION ALL    SELECT SID,           OBJ,           ID,           TITLE,           REVIEW_DATE,           ACTIVITY_DATE_FY      FROM MV_A_DATABASE_CHECK
TYPE_TEXT_LENGTH null
TYPE_TEXT null
OID_TEXT_LENGTH null
OID_TEXT null
VIEW_TYPE_OWNER null
VIEW_TYPE null
SUPERVIEW_NAME null
EDITIONING_VIEW N
READ_ONLY N
CONTAINER_DATA N
BEQUEATH DEFINER
ORIGIN_CON_ID 16
DEFAULT_COLLATION USING_NLS_COMP
CONTAINERS_DEFAULT NO
CONTAINER_MAP NO
EXTENDED_DATA_LINK NO
EXTENDED_DATA_LINK_MAP NO
HAS_SENSITIVE_COLUMN NO
ADMIT_NULL NO
PDB_LOCAL_ONLY NO
DUPLICATED N
SHARDED N
OWNER TRIGGER_NAME TRIGGER_TYPE TRIGGERING_EVENT STATUS OBJECT_ID




ATTRIBUTE Line:Position TEXT